SQLDMO a backup

Otázka od: Vlastimil Zdenek

5. 11. 2003 9:09

Zdravim,
prosil bych o radu. Pouzivam na zalohovani databaze SQLDMO, priklad viz
dale. Tante prikaz ale dela prirustkovou datatbazi. Jakym parametrem se
udela overwrite databaze?
Diky

D5 Ent, MSSQL7, 8

procedure Backup;
var
  SQLServer: SQLDMO.SQLServer;
  Backup: SQLDMO.Backup;
  FInterfaceConnection: Integer;
begin
  FE_ZalDB.Refresh;
  SQLServer := CoSQLServer.Create;
  SQLServer.Connect(Server,User,Password);

  Backup := CoBackup.Create;
  Backup.Database := Database;
  Backup.Files := CestaKam;
  Backup.Ovewrite := True <<<= tady parametr na prepis zalohy dat

  InterfaceConnect(Backup, IID_BackupSink, TBackupSink.Create,
FInterfaceConnection);

  Backup.SQLBackup(SQLServer);

  InterfaceDisconnect(Backup, IID_BackupSink, FInterfaceConnection);
end;

----------
* www.inMail.sk - Vasa emailova adresa na cely zivot ZDARMA
* Mail neobsahuje virusy. Zkontrolovane antivirusom NOD32 (www.eset.sk)
* www.SlovakNET.sk - profesionalny webhosting, domena .SK ZADARMO
* Zoner Media Explorer 5 - stiahnite si pomocnika pre digitalnu fotografiu
(zme.zoner.sk)